/**
 * Software License, Version 1.0
 * 
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 * 
 *
 *Redistribution and use in source and binary forms, with or without 
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright 
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the 
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For 
 * further information contact the Community Grids Lab at 
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and 
 * wherever such third-party acknowledgments normally appear.
 * 
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering, 
 * shall not be used to endorse or promote products derived from this software 
 * without prior written permission from Indiana University.  For written 
 * permission, please contact the Advanced Research and Technology Institute 
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering, 
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 * 
 *
 * Indiana University provides no reassurances that the source code provided 
 * does not infringe the patent or any other intellectual property rights of 
 * any other entity.  Indiana University disclaims any liability to any 
 * recipient for claims brought by any other entity based on infringement of 
 * intellectual property rights or otherwise.  
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO 
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF 
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS. 
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS", 
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.  
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR 
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION 
 *GENERATED USING SOFTWARE.
 */
/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */
/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */

package cgl.narada.wsinfra.wsr.storage.impl;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import cgl.narada.wsinfra.wsr.storage.WsrStorageException;

/**
 * @author Sima Patel
 * $Date: 2005/03/18 20:18:23 $
 * $Revision: 1.3 $
 * Description: Helps to processes that needs to access and
 * store data to the database 
 */

public class WsrQueryHandler {
  Connection connection;

  private String moduleName = "WsrQueryHandler: ";
  public WsrQueryHandler(Connection _connection) {
    connection = _connection;
  }

  /**executes sql query and returns PreparedStatement*/
  public PreparedStatement getPreparedStatement(String sqlQuery) throws
      WsrStorageException {
    try {
      if (connection == null) {
        System.out.println("\n\n" + moduleName +
                           "Connection NOT initialized \n\n");
      }
      PreparedStatement pst = connection.prepareStatement(sqlQuery);

      return pst;
    }
    catch (SQLException se) {
      se.printStackTrace();
      throw new WsrStorageException(moduleName + "executeQuery exception ["
                                     + sqlQuery + "] " + se.toString());
    }
  }

  /** closes the result set objects */
  public void closePreparedStatement(PreparedStatement preparedStatement) throws
      WsrStorageException {

    try {
      preparedStatement.close();
    }
    catch (SQLException ex) {
      throw new WsrStorageException(moduleName + " closeResultSet exception "
                                     + ex.toString());
    }
  }

  /**executes sql query and returns result set*/
  public ResultSet getResultSet(PreparedStatement preparedStatement) throws
      WsrStorageException {
    try {
      ResultSet resultSet = preparedStatement.executeQuery();
      return resultSet;
    }
    catch (SQLException se) {
      se.printStackTrace();
      throw new WsrStorageException(moduleName + "executeQuery exception ["
                                     + "] " + se.toString());
    }
  }

  /** closes the result set objects */
  public void closeResultSet(ResultSet resultSet) throws WsrStorageException {

    try {
      resultSet.close();
    }
    catch (SQLException ex) {
      throw new WsrStorageException(moduleName + " closeResultSet exception "
                                     + ex.toString());
    }
  }

  /** Executes the given SQL statement, which may be an INSERT, UPDATE,
   * or DELETE statement and returns number of rows that are effected*/
  public int updateQuery(String sqlQuery) throws WsrStorageException {
    try {
      Statement stmt = connection.createStatement();
      int rowCount = stmt.executeUpdate(sqlQuery);
      stmt.close();
      return rowCount;
    }
    catch (SQLException se) {
      se.printStackTrace();
      throw new WsrStorageException(moduleName + " updateQuery exception [" +
                                     sqlQuery + "] " + se.toString());
    }
  }
  /** checks whether the parameter exists in the table */
  public boolean isExistInTable(String query) throws WsrStorageException {

    long count = getLongNumber(query);
    if (count > 0) {
      return true;
    }
    return false;
  }

  /** returs the value of count that is provided by query
   * the count is maching row numbers
   * query may be : "select count(*) from tablename "*/
  public long getLongNumber(String query) throws WsrStorageException {
    String count = null;
    PreparedStatement preparedStatement = getPreparedStatement(query);
    ResultSet resultSet = getResultSet(preparedStatement);

    try {
      while (resultSet.next()) {
        count = resultSet.getString(1);
      }
    }
    catch (SQLException ex) {
      throw new WsrStorageException(moduleName + "getLongNumber exception ["
                                     + query + "] " + ex.toString());
    }

    if (count == null) {
      count = new Long(0).toString();
    }

    try {
      preparedStatement.close();
      resultSet.close();
    }
    catch (SQLException ex1) {
      throw new WsrStorageException(moduleName + "getLongNumber exception ["
                                     + query + "] " + ex1.toString());
    }

    long longCount = new Long(count).longValue();
    return longCount;
  }

  /** returns the long values of maching  results in an array
   * such as sequence numbers*/
  public long[] getLongNumbers(ResultSet resultSet) throws
      WsrStorageException {

    Vector resultSetVector = new Vector();
    try {
      while (resultSet.next()) {
        String longValue = resultSet.getString(1);

        if (longValue != null) {
          resultSetVector.add(new Long(longValue));
        }
      }
    }
    catch (SQLException ex) {
      throw new WsrStorageException(moduleName +
                                     " getResultLongNumber exception "
                                     + ex.toString());
    }

    int size = resultSetVector.size();

    if (size <= 0) {
      return null;
    }

    long[] longArray = new long[size];
    for (int i = 0; i < size; i++) {
      longArray[i] = ( (Long) resultSetVector.elementAt(i)).longValue();
    }

    return longArray;

  }

  /** returns the strings of maching  results in an array
   * such as sequence numbers*/
  public String[] getStringArray(ResultSet resultSet) throws
      WsrStorageException {

    Vector resultSetVector = new Vector();
    try {
      while (resultSet.next()) {
        resultSetVector.add(resultSet.getString(1));
      }
    }
    catch (SQLException ex) {
      throw new WsrStorageException(moduleName +
                                     " getStringArray exception "
                                     + ex.toString());
    }

    int size = resultSetVector.size();

    String[] stringArray = new String[size];
    for (int i = 0; i < size; i++) {
      stringArray[i] = (String) resultSetVector.elementAt(i);
    }
    return stringArray;

  }
  public int getIntOfBoolean(boolean value) {

    if (value == true) {
      return 1;
    }

    return 0;
  }

  /** converts integers into boolean values */
  public boolean getBooleanOfInt(int value) {
    if (value != 0) {
      return true;
    }
    return false;
  }
  
  public static void main(String[] args) {
  }

}
